How to: Move within a range of selected cells.
Solution:
Select the range of cells in the worksheet. Press TAB or SHIFT+TAB on the keyboard to navigate within the selected range.
1) Select the desired range of cells. (The selected range is highlighted.)
2) To move within the range while still having the range selected, do one of the following:
a) Press TAB to move left to right one cell at a time and to move down row by row.
b) Press SHIFT+TAB to move right to left one cell at a time and to move up row by row.
c) Press RETURN to move down within a column.
